Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# EDIT

The EDIT command displays an OLAP Worksheet Edit window. The command is available only when you are using OLAP Worksheet to access Oracle OLAP.

For information about using an OLAP Worksheet Edit window, see the OLAP Worksheet Help.

Syntax

EDIT {PROGRAM|MODEL|AGGMAP|FORMULA} object-name

Arguments

PROGRAM
MODEL
AGGMAP
FORMULA

  Indicates whether the object to be edited is a program, a model, an aggmap, or a formula.

object-name

  A text expression that specifies the name of an existing program, model, aggmap, or formula. Before editing one of these objects, use a DEFINE statement to create it in an analytic workspace.

Notes

Editing a Newly Defined Aggmap to Code an Allocation Specification

When an aggmap is first defined it does not have any contents and its type is `NA`. When you use the EDIT command for an aggmap whose type has not yet been specified, OLAP Worksheet automatically makes the aggmap an aggregation specification by inserting an AGGMAP statement into the contents of the aggmap.

Consequently, when you plan to use an aggmap as an allocation specification, use the following statements to identify it as an allocation specification before the first time you open an OLAP Worksheet Edit window for it.

    CONSIDER aggmap-name
         ALLOCMAP 'END'

Examples

Example 11-17 Editing a Program

The following statement, executed in the OLAP Worksheet, places the `myprog` program in an OLAP Worksheet EDIT window.

    EDIT myprog

Example 11-18 Editing a Model

The following statement, executed in the OLAP Worksheet, places a model called `myModel` in an OLAP Worksheet Edit window.

    EDIT MODEL myModel